CREATE TABLE [dbo].[LotLevelHoldingsRaw]
(
[Security Description] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CUSIP] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Lot Number] [float] NULL,
[Trade Date] [datetime] NULL,
[Actual Settlement Date] [datetime] NULL,
[Asset Class] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Base Market Value] [float] NULL,
[Base Original Cost] [float] NULL,
[Shares/Par Value] [float] NULL,
[Base Unrealized Gain/Loss] [float] NULL,
[Amortized Cost - Base] [float] NULL,
[Amortized Cost - Local] [float] NULL,
[Client Fund] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Account Number] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Variable Rate] [float] NULL,
[Trade ID] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Moody's Quality Rating] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Maturity Date] [datetime] NULL,
[Interest Rate] [float] NULL,
[IM ID] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Alternate Lot Number] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Issued at OID] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Dummy Cusip Indicator] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ISIN Number] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Report Date] [datetime] NULL,
[Post Date] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Cash Date] [datetime] NULL
) ON [PRIMARY]
GO
